package com.sunwayworld.basemodule.business.qualitycontrol.qualitycontrolresult.dao;

import com.sunwayworld.basemodule.business.qualitycontrol.qualitycontrolresult.bean.LimsQualitycontrolTestResultBean;
import com.sunwayworld.framework.mybatis.mapper.MapperParameter;
import com.sunwayworld.framework.support.base.dao.GenericDao;

import java.util.List;
import java.util.Map;

public interface LimsQualitycontrolTestResultDao extends GenericDao<LimsQualitycontrolTestResultBean, Long> {

    List<Map<String, Object>> selectDistinctRows(MapperParameter parameter) ;

    double selectAverageForHistory(String mainBatchCode, String controlMaterialLevel, String productName);

    double selectSDForHistory(String mainBatchCode, String controlMaterialLevel, String productName);
}
